package org.upfrost.idiom;

/**
 * MySQL implementation of the SQLIdiom interface. MySQL as different reserved keywords and a different default way to quote
 * them then sql92: it uses ` instead of the double quote (although this can be overridden with the ANSI_QUOTES SQL mode). This
 * class registers all the keywords up to version 6 of MySQL.
 * 
 * @author Rodrigo Reyes
 *
 */
public class MySQLIdiom extends GenericSQL92 
{
	static private String[] MYSQL_RESERVED_KEYWORDS = {
		"ACCESSIBLE", "ADD", "ALL", "ALTER", "ANALYZE", "AND", 
		"AS", "ASC", "ASENSITIVE", "BEFORE", "BETWEEN", "BIGINT", 
		"BINARY", "BLOB", "BOTH", "BY", "CALL", "CASCADE", 
		"CASE", "CHANGE", "CHAR", "CHARACTER", "CHECK", "COLLATE", 
		"COLUMN", "CONDITION", "CONSTRAINT", "CONTINUE", "CONVERT", "CREATE", 
		"CROSS", "CURRENT_DATE", "CURRENT_TIME", "CURRENT_TIMESTAMP", "CURRENT_USER", 
		"CURSOR", "DATABASE", "DATABASES", "DAY_HOUR", "DAY_MICROSECOND", "DAY_MINUTE", 
		"DAY_SECOND", "DEC", "DECIMAL", "DECLARE", "DEFAULT", "DELAYED", 
		"DELETE", "DESC", "DESCRIBE", "DETERMINISTIC", "DISTINCT", "DISTINCTROW", 
		"DIV", "DOUBLE", "DROP", "DUAL", "EACH", "ELSE", 
		"ELSEIF", "ENCLOSED", "ESCAPED", "EXISTS", "EXIT", "EXPLAIN", 
		"FALSE", "FETCH", "FLOAT", "FLOAT4", "FLOAT8", "FOR", 
		"FORCE", "FOREIGN", "FROM", "FULLTEXT", "GRANT", "GROUP", 
		"HAVING", "HIGH_PRIORITY", "HOUR_MICROSECOND", "HOUR_MINUTE", "HOUR_SECOND", "IF", 
		"IGNORE", "IGNORE_SERVER_IDS", "IN", "INDEX", "INFILE", "INNER", 
		"INOUT", "INSENSITIVE", "INSERT", "INT", "INT1", "INT2", 
		"INT3", "INT4", "INT8", "INTEGER", "INTERVAL", "INTO", 
		"IS", "ITERATE", "JOIN", "KEY", "KEYS", "KILL", 
		"LEADING", "LEAVE", "LEFT", "LIKE", "LIMIT", "LINEAR", 
		"LINES", "LOAD", "LOCALTIME", "LOCALTIMESTAMP", "LOCK", "LONG", 
		"LONGBLOB", "LONGTEXT", "LOOP", "LOW_PRIORITY", "MASTER_HEARTBEAT_PERIOD", "MASTER_SSL_VERIFY_SERVER_CERT", 
		"MATCH", "MEDIUMBLOB", "MEDIUMINT", "MEDIUMTEXT", "MIDDLEINT", "MINUTE_MICROSECOND", 
		"MINUTE_SECOND", "MOD", "MODIFIES", "NATURAL", "NOT", "NO_WRITE_TO_BINLOG", 
		"NULL", "NUMERIC", "ON", "OPTIMIZE", "OPTION", "OPTIONALLY", 
		"OR", "ORDER", "OUT", "OUTER", "OUTFILE", "OVERWRITE", 
		"PRECISION", "PRIMARY", "PROCEDURE", "PURGE", "RANGE", "READ", 
		"READS", "READ_ONLY", "READ_WRITE", "REAL", "REFERENCES", "REGEXP", 
		"RELEASE", "RENAME", "REPEAT", "REPLACE", "REQUIRE", "RESIGNAL",
		"RESTRICT", "RETURN", "REVOKE", "RIGHT", "RLIKE", "SCHEMA", 
		"SCHEMAS", "SECOND_MICROSECOND", "SELECT", "SENSITIVE", "SEPARATOR", "SET", 
		"SHOW", "SIGNAL", "SKIP_GAP_EVENT", "SMALLINT", "SPATIAL", "SPECIFIC", 
		"SQL", "SQLEXCEPTION", "SQLSTATE", "SQLWARNING", "SQL_BIG_RESULT", "SQL_CALC_FOUND_ROWS", 
		"SQL_SMALL_RESULT", "SSL", "STARTING", "STRAIGHT_JOIN", "TABLE", "TERMINATED", 
		"THEN", "TINYBLOB", "TINYINT", "TINYTEXT", "TO", "TRAILING", 
		"TRIGGER", "TRUE", "UNDO", "UNION", "UNIQUE", "UNLOCK", 
		"UNSIGNED", "UPDATE", "USAGE", "USE", "USING", "UTC_DATE", 
		"UTC_TIME", "UTC_TIMESTAMP", "VALUES", "VARBINARY", "VARCHAR", "VARCHARACTER", 
		"VARYING", "WHEN", "WHERE", "WHILE", "WITH", "WRITE", 
		"XOR", "YEAR_MONTH", "ZEROFILL"
	};

	public MySQLIdiom()
	{
		super(MYSQL_RESERVED_KEYWORDS);
	}

	@Override
	protected String addQuotesToIdentifier(String name) 
	{
		return "`" + name + "`";
	}

}
